{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["1","2","3","4","5","6","7","8","9","10","11","12"],"read":"whole","date_system":"1900"}

{"sheet":"1","index":0,"n_rows":38,"n_cols":18,"rows_kept":38,"merged":[[6,0,6,17],[7,0,7,17],[8,0,10,0],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,6,10,6],[8,7,10,7],[8,8,10,8],[8,9,10,9],[8,10,9,11],[8,12,8,17],[9,12,9,13],[9,14,9,15],[9,16,9,17],[11,0,11,1],[12,0,17,0],[27,0,30,0],[31,0,33,0],[31,1,33,1],[36,0,37,0],[37,1,37,2]]}
["Согласовано:"]
["Начальник отдела образования"]
[" исполнительного комитета"]
["Мамадышского муниципального района"]
[null,"И.Н.Габдрахманов"]
[]
["Примерное двухнедельное меню школьных завтраков  для организации питания детей , .С прибыванием детей до 6 часов (5-11кл)"]
["                                            Использован: Сборник рецептур блюд и кулинарных изделий для предприятий общетвенного питания 1993 и 1996гг.Сборник рецептур блюд и кулинарный изделий татарской нацинальной кухни 1997г."]
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["1 день"]
["№10","салат из свежей  капусты ","капуста",99.6,79,null,1.4,null,3.7,21.3,25,{"$f":"D13*K13/1000","v":2.49},null,{"$f":"D13*M13/1000","v":{"v":0,"d":"0.00"}},25,{"$f":"D13*O13/1000","v":2.49}]
[null,null,"лук",12.5,10,null,0.14,null,0.91,4.1,30,{"$f":"D14*K14/1000","v":{"v":0.375,"d":"0.38"}},null,{"$f":"D14*M14/1000","v":{"v":0,"d":"0.00"}},30,{"$f":"D14*O14/1000","v":{"v":0.375,"d":"0.38"}}]
[null,null,"морковь",12.5,10,null,0.1,null,0.7,3.4,35,{"$f":"D15*K15/1000","v":{"v":0.4375,"d":"0.44"}},null,{"$f":"D15*M15/1000","v":{"v":0,"d":"0.00"}},35,{"$f":"D15*O15/1000","v":{"v":0.4375,"d":"0.44"}}]
[null,null,"сахар",5,5,{"$nulls":3},4.9,18.9,80,{"$f":"D16*K16/1000","v":{"v":0.4,"d":"0.40"}},null,{"$f":"D16*M16/1000","v":{"v":0,"d":"0.00"}},80,{"$f":"D16*O16/1000","v":{"v":0.4,"d":"0.40"}}]
[null,null,"масло растительное ",5,5,null,null,4.99,null,44.9,140,{"$f":"D17*K17/1000","v":{"v":0.7,"d":"0.70"}},140,{"$f":"D17*M17/1000","v":{"v":0.7,"d":"0.70"}},null,{"$f":"D17*O17/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"итого",null,null,100]
["№610","Биточки из говядины","Говядина (котлетное  мясо)",72,72,null,6.32,4.08,null,55.59,500,{"$f":"D19*K19/1000","v":{"v":36,"d":"36.00"}},null,{"$f":"D19*M19/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D19*O19/1000","v":{"v":0,"d":"0.00"}},500,{"$f":"D19*Q19/1000","v":36}]
[null,null,"Сухари",1,2,null,0.22,0.02,1.44,6.62,100,{"v":0.1,"d":"0.10"},100,{"v":0.1,"d":"0.10"},null,{"v":0,"d":"0.00"}]
[null,null,"Хлеб ржанойй",7,7,null,0.57,0.06,0.47,15.82,78,{"v":0.546,"d":"0.55"},51,{"v":0.357,"d":"0.36"},null,{"v":0,"d":"0.00"}]
[null,null,"Масло сливочное",5,5,null,0.04,3.6,0.06,33.05,900,{"v":4.5,"d":"4.50"},900,{"v":4.5,"d":"4.50"},null,{"v":0,"d":"0.00"}]
[null,null,"Соль",0.6,0.6,null,"-","-","-","-",16,{"v":0.0096,"d":"0.01"},16,{"v":0.0096,"d":"0.01"},null,{"v":0,"d":"0.00"}]
[null,null,"Масса п/ф",null,50,null,"-",null,"-","-",null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"}]
[null,null,"Масло растительное",3,3,null,"-",1.99,"-",17.98,140,0.42,140,0.42,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},100]
[{"$nulls":11},{"$f":"D27*K27/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D27*M27/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D27*O27/1000","v":{"v":0,"d":"0.00"}}]
["№746","Каша гречневая","Крупа гречневая",50,null,null,5.9,1.65,30.95,167.5,100,{"$f":"D28*K28/1000","v":{"v":5,"d":"5.00"}},100,{"$f":"D28*M28/1000","v":{"v":5,"d":"5.00"}},null,{"$f":"D28*O28/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"Масло сливочное",5,null,null,0.04,3.6,0.06,33.05,900,{"$f":"D29*K29/1000","v":{"v":4.5,"d":"4.50"}},900,{"$f":"D29*M29/1000","v":{"v":4.5,"d":"4.50"}},null,{"$f":"D29*O29/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"Соль",0.5,null,null,"-","-",null,null,16,{"$f":"D30*K30/1000","v":{"v":0.008,"d":"0.01"}},16,{"$f":"D30*M30/1000","v":{"v":0.008,"d":"0.01"}},null,{"$f":"D30*O30/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"итого",null,null,180]
["№944","Чай с сахаром","Заварка",1,1,null,0.04,"-","-",null,688,{"$f":"D32*K32/1000","v":{"v":0.688,"d":"0.69"}},688,{"$f":"D32*M32/1000","v":{"v":0.688,"d":"0.69"}},null,{"$f":"D32*O32/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"Сахар",15,15,null,0,null,14.9,58,80,{"$f":"D33*K33/1000","v":{"v":1.2,"d":"1.20"}},80,{"$f":"D33*M33/1000","v":{"v":1.2,"d":"1.20"}},null,{"$f":"D33*O33/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"итого",null,null,"200/7",{"$nulls":10},{"$f":"SUM(Q32:Q33)","v":0}]
[null,"хлеб","хлеб",20,20,20,{"$nulls":4},76,1.02,76,1.02]
[null,"хлеб","хлеб",30,30,30,12.16,1.44,79.76,180.8,78,{"$f":"D36*K36/1000","v":2.34},78,{"$f":"D36*M36/1000","v":2.34},null,{"$f":"D36*O36/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"итого",null,null,50,{"$nulls":5},{"$f":"SUM(L13:L36)","v":{"v":60.73410000000001,"d":"60.73"}},null,{"$f":"SUM(N13:N36)","v":{"v":20.842599999999997,"d":"20.84"}},null,{"$f":"SUM(P13:P36)","v":{"v":3.7025,"d":"3.70"}},null,{"$f":"R19","v":36}]
[null,"итого за день"]

{"sheet":"2","index":1,"n_rows":26,"n_cols":18,"rows_kept":26,"merged":[[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[3,0,6,0],[7,0,16,0],[17,0,20,0],[17,1,18,1],[25,0,25,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[null,"2 день",{"$nulls":10},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№273"]
[]
[]
[null,null,"итого",null,null,100,{"$f":"SUM(G4:G6)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["№411","Фрукты","Яблоки",100,100,100,0,0,10.98,47.52,100,{"$f":"K8/1000*D8","v":{"v":10,"d":"10.00"}},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},100,{"$f":"D8*K8/1000","v":10}]
[null,"Рагу из птицы","курица",100,100,{"$nulls":5},270,{"$f":"K9/1000*D9","v":{"v":27,"d":"27.00"}},null,{"v":0,"d":"0.00"},null,null,270,{"$f":"D9*Q9/1000","v":{"v":27,"d":"27.00"}}]
[null,null,"картофель",63.7,null,null,0.6,0.12,4.98,24.4,25,{"v":1.5925000000000002,"d":"1.59"},null,{"$f":"D10*M10/1000","v":{"v":0,"d":"0.00"}},25,{"$f":"D10*O10/1000","v":{"v":1.5925,"d":"1.59"}},null,{"$f":"D10*Q10/1000","v":0}]
[null,null,"соль",2,2,{"$nulls":5},16,{"v":0.032,"d":"0.03"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},16,0.032]
[null,null,"морковь",28.4,22.7,null,0.19,null,1.08,5.13,35,{"v":0.994,"d":"0.99"},null,{"v":0,"d":"0.00"},35,{"v":0.994,"d":"0.99"},null,0]
[null,null,"лук",14.3,12,null,0.1,null,1.08,3.28,30,{"v":0.429,"d":"0.43"},null,{"v":0,"d":"0.00"},30,{"v":0.429,"d":"0.43"},null,0]
[null,null,"капуста ",69.8,57,null,0.6,0.03,0.72,9.9,25,{"v":1.745,"d":"1.75"},null,{"$f":"D14*M14/1000","v":{"v":0,"d":"0.00"}},25,{"$f":"D14*O14/1000","v":{"v":1.745,"d":"1.75"}},null,{"$f":"D14*Q14/1000","v":0}]
[null,null,"масло растительное ",4,4,null,0.048,4.35,0.156,39.66,140,0.56,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},140,{"$f":"D15*K15/1000","v":0.56}]
[null,null,"томат паста",2,2,null,0.4,2.9,0.05,9.9,175,0.35,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},175,{"$f":"D16*K16/1000","v":0.35}]
[{"$nulls":5},180]
["№959","Кофейный  напиток с молоком","Кофейный напиток",5,5,5,54,2.16,0.74,24.42,500,{"v":2.5,"d":"2.50"},500,{"$f":"D18*K18/1000","v":2.5},{"$nulls":3},0]
[null,null,"Сахар",20,20,20,0,0,11.088,42.67,80,{"v":1.6,"d":"1.60"},80,{"$f":"D19*K19/1000","v":1.6},{"$nulls":3},0]
[null,null,"Молоко",100,100,100,2.82,3.2,4.3,58,83,{"v":8.3,"d":"8.30"},83]
[null,null,"выход",null,null,200,{"$nulls":7},{"$f":"D21*K21/1000","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"хлеб пшеничный ","хлеб",30,30,30,6.96,1.2,46,167.2,78,2.34,null,{"$f":"D22*M22/1000","v":{"v":0,"d":"0.00"}},{"$f":"G22*N22/1000","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},78,{"$f":"D22*K22/1000","v":2.34}]
[null,"хлеб пшенично-ржаной","хлеб",20,20,20,6.96,1.02,46,167.2,76,1.52,null,{"$f":"D23*M23/1000","v":{"v":0,"d":"0.00"}},null,null,{"v":76,"d":"76.00"},{"$f":"D23*Q23/1000","v":1.52}]
[]
[null,null,"итого",{"$nulls":8},{"v":0,"d":"0.0"},{"$nulls":3},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
["итого за день",{"$nulls":10},{"$f":"SUM(L8:L25)","v":{"v":58.96250000000001,"d":"58.96"}},null,{"$f":"SUM(N8:N25)","v":{"v":4.1,"d":"4.10"}},null,{"$f":"SUM(P8:P25)","v":{"v":4.7605,"d":"4.76"}},null,{"$f":"SUM(R8:R25)","v":{"v":41.802,"d":"41.80"}}]

{"sheet":"3","index":2,"n_rows":24,"n_cols":18,"rows_kept":24,"merged":[[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[4,1,5,1],[12,0,15,0],[19,1,20,1],[21,0,22,0]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[null,"3 день",{"$nulls":10},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[]
["№610","Гуляш из говядины","Говядина",87,74,null,16.89,12.9,null,174.9,500,{"$f":"D5*K5/1000","v":{"v":43.5,"d":"43.50"}},{"$nulls":3},{"$f":"D5*O5/1000","v":{"v":0,"d":"0.00"}},500,{"$f":"D5*Q5/1000","v":43.5}]
[null,null,"Масло растительное",5,5,null,null,4.99,null,44.95,140,{"v":0.7,"d":"0.70"},140,{"$f":"D6*M6/1000","v":{"v":0.7,"d":"0.70"}},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Лук репчатый",18,15,null,0.21,"-",1.36,6.15,30,0.54,null,null,30,{"$f":"D7*O7/1000","v":0.54},null,0]
[null,null,"Томат паста",3.2,3.2,null,0.43,null,1.87,9.16,175,0.56,175,0.56,null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",1,3,null,"-","-","-","-",16,{"v":0.016,"d":"0.02"},16,{"v":0.016,"d":"0.02"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"Масса тушен.мяса",null,50,null,"-",null,"-","-",null,{"v":0,"d":"0.00"},{"$nulls":3},{"v":0,"d":"0.00"},null,0]
[null,null,"Мука",4,4,null,0.43,0.04,2.72,13.08,40,0.16,{"$nulls":3},{"v":0,"d":"0.00"},40,{"$f":"D11*Q11/1000","v":0.16}]
[{"$nulls":5},100,18.19,17.93,6.92,250.4]
["№746","Макароны отварные","макароны",51,null,null,3.5,0.37,23.6,114.5,60,{"$f":"D13*K13/1000","v":3.06},60,{"$f":"D13*M13/1000","v":{"v":3.06,"d":"3.1"}},null,{"$f":"D13*O13/1000","v":{"v":0,"d":"0.00"}},null,0]
[null,null,"Соль",3,null,null,"-","-","-","-",16,{"$f":"D14*K14/1000","v":{"v":0.048,"d":"0.05"}},16,{"$f":"D14*M14/1000","v":{"v":0.048,"d":"0.05"}},null,{"$f":"D14*O14/1000","v":{"v":0,"d":"0.00"}},null,0]
[null,null,"Масло слив",5,null,null,0.02,2.5,0.04,23.1,900,{"$f":"D15*K15/1000","v":{"v":4.5,"d":"4.50"}},900,{"$f":"D15*M15/1000","v":{"v":4.5,"d":"4.50"}},null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},null,0]
[null,null,"итого",null,null,180,{"$f":"SUM(G13:G15)","v":3.52},2.87,23.64,137.6]
["№944","Чай с сахаром","заварка",1,1,1,{"$nulls":4},688,6.88,688,6.88]
[null,null,"Сахар",15,15,null,0,"-",14.9,56.8,80,{"$f":"D18*K18/1000","v":{"v":1.2,"d":"1.20"}},80,{"$f":"D18*M18/1000","v":{"v":1.2,"d":"1.20"}},null,{"$f":"D18*O18/1000","v":{"v":0,"d":"0.00"}},null,0]
[null,null,"итого",null,null,200,{"$f":"SUM(G17:G18)","v":0}]
[null,"хлеб иодированный","хлеб",30,30,30,6.96,1.2,46,167.2,78,1.8,78,1.8]
[null,null,"хлеб",20,20,20,6.96,1.2,46,167.2,76,{"$f":"D21*K21/1000","v":1.52},76,{"$f":"D21*K21/1000","v":1.52},null,{"$f":"D21*O21/1000","v":{"v":0,"d":"0.00"}},null,0]
[]
[{"$nulls":6},{"$f":"SUM(G22:G22)","v":0},{"$f":"SUM(H22:H22)","v":0},{"$f":"SUM(I22:I22)","v":0},{"$f":"SUM(J22:J22)","v":0},null,{"v":0,"d":"0.00"},{"$f":"SUM(M22:M22)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["итого за день",{"$nulls":5},{"$f":"G23+G21+G19+G11","v":{"v":7.39,"d":"7.390"}},{"$f":"H23+H21+H19+H11","v":{"v":1.24,"d":"1.240"}},{"$f":"I23+I21+I19+I11","v":{"v":48.72,"d":"48.720"}},{"$f":"J23+J21+J19+J11","v":{"v":180.28,"d":"180.280"}},null,{"$f":"SUM(L5:L23)","v":{"v":64.48400000000001,"d":"64.484"}},null,{"$f":"SUM(N6:N23)","v":{"v":20.284,"d":"20.28"}},null,{"$f":"SUM(P5:P23)","v":{"v":0.54,"d":"0.540"}},null,{"$f":"SUM(R5:R23)","v":43.66}]

{"sheet":"4","index":3,"n_rows":29,"n_cols":18,"rows_kept":29,"merged":[[0,0,0,17],[1,0,1,17],[2,0,4,0],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,7,4,7],[2,8,4,8],[2,9,4,9],[2,10,3,11],[2,12,2,17],[3,12,3,13],[3,14,3,15],[3,16,3,17],[5,0,5,1],[6,0,9,0],[6,1,9,1],[11,1,12,1],[16,0,19,0],[21,0,23,0],[21,1,23,1],[25,0,27,0],[28,0,28,1]]}
[]
[]
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["4 день"]
["№273","Салат из моркови","Морковь",65,60,60,1.3,0.08,6.06,27.2,35,{"$f":"D7*K7/1000","v":{"v":2.275,"d":"2.28"}},null,null,35,2.27]
[null,null,"Масло растительное",6,6,6,0,6.93,0,62.93,140,{"$f":"D8*K8/1000","v":0.84},{"$nulls":4},140,{"$f":"D8*Q8/1000","v":0.84}]
[null,null,"Сахарный песок",6,6,6,0,0,9.98,37.9,80,0.48,{"$nulls":4},80,{"$f":"D9*Q9/1000","v":0.48}]
[]
[null,null,"итого",null,null,"60"]
["№517","Котлеты Рыбные","Котлеты рыбные п/ф из судака(трески)",100,100,null,27.4,5.24,0,110,325,{"v":32.5,"d":"32.50"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},325,{"$f":"D12*Q12/1000","v":32.5}]
[{"$nulls":5},100]
[]
[]
[{"$nulls":11},{"v":0,"d":"0.00"},null,{"$f":"D16*M16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*Q16/1000","v":0}]
["№442","Картофельное пюре","Картофель",170,150,null,5.01,0.72,31.19,144.29,25,4.25,null,null,25,{"v":4.25,"d":"4.3"}]
[null,null,"Молоко 2,5",24,24,null,0.67,0.76,1.12,13.9,83,{"v":1.992,"d":"1.99"},83,{"$f":"D18*M18/1000","v":{"v":1.992,"d":"1.99"}}]
[null,null,"Масло слив",5.2,null,null,0.04,3.77,0.13,34.37,900,4.68,900,{"$f":"D19*M19/1000","v":4.68}]
[null,null,"Соль",1,{"$nulls":6},16,{"v":0.016,"d":"0.02"},16,0.02]
[{"$nulls":5},180]
["№944","Чай с сахаром","Заварка",1,1,null,0.04,"-","-",null,688,{"v":0.688,"d":"0.69"},688,{"$f":"D22*M22/1000","v":{"v":0.688,"d":"0.69"}},null,{"$f":"D22*O22/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D22*Q22/1000","v":0}]
[null,null,"Сахар",15,15,null,0,null,14.9,58,80,{"v":1.2,"d":"1.20"},80,{"$f":"D23*M23/1000","v":{"v":1.2,"d":"1.20"}},null,{"$f":"D23*O23/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D23*Q23/1000","v":0}]
[null,null,"итого",null,null,"200/7",{"$nulls":5},{"v":0,"d":"0.00"}]
[null,"хлеб","хлеб",30,30,30,12.16,1.44,79.76,180.8,78,2.34,78,{"$f":"D25*M25/1000","v":2.34},null,{"$f":"D25*O25/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D25*Q25/1000","v":0}]
[null,null,"хлеб",20,20,20,{"$nulls":4},76,1.52,76,{"$f":"D26*K26/1000","v":1.52}]
[null,null,"итого",null,null,50,{"$f":"SUM(G26:G26)","v":0},0,0,0,null,0,null,0,0,{"v":0,"d":"0.00"},0,0]
[{"$nulls":6},{"$f":"G11+G15+G20+G24+G25+G27","v":12.16},1.44,79.76,180.8,94,{"$f":"SUM(L7:L27)","v":{"v":52.781,"d":"52.78"}},null,{"$f":"SUM(N18:N27)","v":{"v":12.439999999999998,"d":"12.44"}},null,{"$f":"SUM(P7:P27)","v":6.52},null,{"$f":"SUM(R8:R27)","v":33.82}]
["итого за день"]

{"sheet":"5","index":4,"n_rows":21,"n_cols":18,"rows_kept":21,"merged":[[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[4,0,5,0],[4,1,7,1],[7,0,12,0],[13,0,16,0],[13,1,15,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[null,"5 день",{"$nulls":10},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"Фрукты","Яблоки",100,100,100,0.08,0.069,1.79,7.8,{"v":100,"d":"100.00"},{"$f":"D4*K4/1000","v":{"v":10,"d":"10.00"}},{"$nulls":4},100,{"$f":"D4*Q4/1000","v":10}]
[null,"Котлеты рубленные из птицы","Котлета куриная",90,80,null,11,13.5,4.78,185,{"v":360,"d":"360.00"},{"$f":"D5*K5/1000","v":{"v":32.4,"d":"32.40"}},{"$nulls":4},360,{"$f":"D5*Q5/1000","v":32.4}]
[null,null,"Сухари",8,8,{"$nulls":5},100,{"v":0.8,"d":"0.80"},78,{"$f":"D6*K6/1000","v":0.8}]
[null,null,"Масло сливоч",2,2,{"$nulls":5},900,{"v":1.8,"d":"1.80"},null,0,null,null,900,1.8]
[null,null,"Масло растительное",5,5,{"$nulls":5},140,{"v":0.7,"d":"0.70"},null,0,null,null,140,0.7]
[{"$nulls":5},100]
[null,"Рис отварной","рис",55,55,null,1.16,0.42,10.58,52.55,90,4.95,null,0,null,null,90,4.95]
[null,null,"масло сливочное ",7,7,null,0.04,3.63,0.13,33.05,900,{"v":6.3,"d":"6.30"},null,0,null,{"$f":"D11*O11/1000","v":{"v":0,"d":"0.00"}},900,6.3]
[null,null,"Соль",1,1,null,"-","-","-","-",16,{"v":0.016,"d":"0.02"},16,{"$f":"D12*K12/1000","v":0.016},null,{"$f":"D12*O12/1000","v":{"v":0,"d":"0.00"}},null,0]
[null,null,"итого",null,null,180,{"$nulls":7},0,{"$nulls":3},0]
["№944","Чай с лимоном","заварка",1,1,null,0,0,0,0,688,{"v":0.688,"d":"0.69"},688,0.688,null,{"$f":"D14*O14/1000","v":{"v":0,"d":"0.00"}},0,0]
[null,null,"лимон",8,8,null,0,0,0,0,170,1.36,null,0,null,{"$f":"D15*O15/1000","v":{"v":0,"d":"0.00"}},170,1.36]
[null,null,"Сахар",15,15,{"$nulls":3},19.96,75,80,{"v":1.2,"d":"1.20"},80,1.2,null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},null,0]
[{"$nulls":5},200,{"$nulls":5},{"v":0,"d":"0.00"},null,0,{"$nulls":3},0]
[null,"хлеб","хлеб",20,20,20,6.96,1.2,32.96,181,78,1.56,51,1.56,{"$nulls":3},0]
[null,"хлеб","хлеб",30,30,30,null,1.2,46,167.2,76,2.28,60,2.28,null,{"v":0,"d":"0.00"},null,0]
[null,null,"итого",null,null,75,{"$nulls":5},{"$f":"SUM(L4:L19)","v":{"v":64.054,"d":"64.05"}},null,{"$f":"SUM(N6:N19)","v":6.543999999999999},{"$nulls":3},{"$f":"SUM(R4:R19)","v":57.51}]
[null,"итого за день"]

{"sheet":"6","index":5,"n_rows":22,"n_cols":18,"rows_kept":22,"merged":[[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[4,0,10,0],[4,1,10,1],[12,0,14,0],[12,1,14,1],[16,0,18,0],[19,1,20,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[null,"6 день",{"$nulls":10},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"Фрукты","Апельсин",100,100,100,{"$nulls":4},{"v":150,"d":"150.0"},{"$f":"K4*D4/1000","v":15},{"$nulls":4},150,15]
["№561","Мясо тушеное","Говядина",83,60,null,{"v":16.69,"d":"16.7"},12.9,{"v":0,"d":"0.0"},165.5,{"v":500,"d":"500.0"},{"$f":"K5*D5/1000","v":41.5},{"$nulls":4},500,{"$f":"D5*K5/1000","v":41.5}]
[null,null,"Морковь",5,3,null,{"v":0.16,"d":"0.2"},{"v":0,"d":"0.0"},{"v":0.84,"d":"0.8"},3.4,{"v":35,"d":"35.0"},0.175,null,null,35,0.17]
[null,null,"Лук",5,3,null,0.4,{"v":0,"d":"0.0"},{"v":2.39,"d":"2.4"},{"v":9.98,"d":"10.0"},{"v":30,"d":"30.0"},0.15,null,null,30,0.15]
[null,null,"Масло рас",5,5,null,{"v":0,"d":"0.0"},{"v":6.99,"d":"7.0"},{"v":0,"d":"0.0"},{"v":62.93,"d":"62.9"},{"v":140,"d":"140.0"},0.7,140,0.7]
[null,null,"Томатная паста",7,7,null,0.1,{"v":0,"d":"0.0"},{"v":0.37,"d":"0.4"},{"v":2.04,"d":"2.0"},{"v":175,"d":"175.0"},1.225,175,1.22]
[null,null,"Мука пшенич",2,2,null,{"v":0.41,"d":"0.4"},{"v":0.04,"d":"0.0"},{"v":2.71,"d":"2.7"},{"v":13.08,"d":"13.1"},{"v":40,"d":"40.0"},0.08,{"v":40,"d":"40.0"},0.08]
[null,null,"соль",1,1,250,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,{"v":16,"d":"16.0"},0.016,{"v":16,"d":"16.0"},{"$f":"D11*K11/1000","v":0.016}]
[{"$nulls":5},2]
["№442","Макароны отварные","Макаронные изделия",53,53,null,{"v":4.06,"d":"4.1"},{"v":0.43,"d":"0.4"},{"v":27.18,"d":"27.2"},{"v":142.13,"d":"142.1"},{"v":60,"d":"60.0"},3.18,60,{"$f":"D13*K13/1000","v":3.18}]
[null,null,"Масло сливочное",5,5,null,{"v":0.08,"d":"0.1"},{"v":7.25,"d":"7.3"},{"v":0.26,"d":"0.3"},66.1,{"v":900,"d":"900.0"},4.5,{"$nulls":4},900,{"$f":"D14*K14/1000","v":4.5}]
[null,null,"соль",1,1,{"$nulls":5},{"v":16,"d":"16.0"},0.016]
[{"$nulls":5},180]
[null,"Чай с сахаром","Заварка",1,1,null,0,{"$nulls":3},688,0.688,688,{"$f":"D17*M17/1000","v":{"v":0.688,"d":"0.69"}}]
[null,null,"Сахар",15,15,null,{"$f":"SUM(F18)","v":0},null,14.9,56.8,80,1.2,80,{"$f":"D18*M18/1000","v":{"v":1.2,"d":"1.20"}}]
[null,null,"итого",null,null,200]
[null,"хлеб","хлеб",20,20,20,6.96,1.2,32.96,181,76,1.52,76,{"$f":"D20*K20/1000","v":1.52}]
[null,null,"хлеб",30,30,30,6.96,1.2,46,167.2,78,2.34,78,{"$f":"D21*K21/1000","v":2.34},null,{"v":0,"d":"0.00"},null,0]
["итого за день",{"$nulls":10},{"$f":"SUM(L4:L21)","v":{"v":72.29,"d":"72.3"}},null,{"$f":"SUM(N7:N21)","v":{"v":10.943999999999999,"d":"10.9"}},null,{"$f":"SUM(P6:P21)","v":{"v":0.32,"d":"0.3"}},null,{"$f":"SUM(R4:R21)","v":{"v":61,"d":"61.0"}}]

{"sheet":"7","index":6,"n_rows":16,"n_cols":20,"rows_kept":16,"merged":[[0,0,2,0],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,2,10],[0,11,2,11],[0,12,1,13],[0,14,0,19],[1,14,1,15],[1,16,1,17],[1,18,1,19],[5,0,8,0],[5,1,6,1],[7,1,8,1],[10,0,12,0],[15,0,15,1]]}
["№ рецепта","Наименование блюд",null,null,"Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":14},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[null,"7 день",{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"Фрукты",null,null,"Апельсин",100,100,100,0,0,10.9,47.52,150,15,150,15,null,null,150,15]
[]
["№326","Сосиски говяжие",null,null,"сосиски гов",102,100,100,18.4,11.9,null,161.9,380,{"$f":"F6*M6/1000","v":38.76},null,{"v":0,"d":"0.00"},null,{"$f":"F6*Q6/1000","v":{"v":0,"d":"0.00"}},380,{"$f":"F6*M6/1000","v":38.76}]
[{"$nulls":4},"Гречка",54,40,{"$nulls":3},5.99,215.2,100,{"$f":"F7*M7/1000","v":{"v":5.4,"d":"5.40"}},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"$f":"F7*M7/1000","v":5.4}]
[null,"Каша гречневая",null,null,"Слив масло",5,5,null,0.04,3.63,0.13,157.9,900,{"v":4.5,"d":"4.50"},null,{"v":0,"d":"0.00"},null,null,800,4.5]
[{"$nulls":4},"соль ",1,1,{"$nulls":5},16,{"v":0.016,"d":"0.02"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,0.016]
[{"$nulls":7},180]
["№944","Какао  с молоком",null,null,"Какао",4,4,{"$nulls":3},"-","-",271,{"v":1.084,"d":"1.08"},271,{"$f":"F11*M11/1000","v":{"v":1.084,"d":"1.08"}},null,{"$f":"F11*Q11/1000","v":{"v":0,"d":"0.00"}},null,0]
[{"$nulls":4},"Сахар",15,15,{"$nulls":3},14.9,56.8,80,{"v":1.2,"d":"1.20"},80,{"v":1.2,"d":"1.20"},null,{"$f":"F12*Q12/1000","v":{"v":0,"d":"0.00"}},null,0]
[{"$nulls":4},"Молоко",100,100,200,{"$nulls":4},83,{"v":8.3,"d":"8.30"},null,{"v":8.3,"d":"8.30"},null,{"$f":"F13*Q13/1000","v":0},null,0]
[{"$nulls":4},"хлеб",20,20,20,6.96,1.2,32.96,181,76,1.52,76,1.52,{"$nulls":3},0]
[null,"хлеб ",null,null,"хлеб",30,30,30,6.96,1.2,32.96,167.2,78,2.34,78,2.34,null,{"$f":"F15*Q15/1000","v":{"v":0,"d":"0.00"}},null,0]
["итого за день",{"$nulls":12},{"$f":"SUM(N6:N15)","v":{"v":63.120000000000005,"d":"63.12"}},null,{"$f":"SUM(P6:P15)","v":{"v":14.443999999999999,"d":"14.44"}},{"$nulls":3},{"$f":"SUM(T6:T15)","v":{"v":48.675999999999995,"d":"48.68"}}]

{"sheet":"8","index":7,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[7,0,13,0],[15,0,18,0],[15,1,17,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[null,"8 день",{"$nulls":8},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[]
[]
[]
[]
[null,"Плов из птицы","Курица",90,50,null,12.8,20.1,0.5,225,270,{"$f":"D8*K8/1000","v":{"v":24.3,"d":"24.30"}},{"$nulls":4},270,{"$f":"D8*K8/1000","v":24.3}]
[null,null,"масло рас",7,7,null,0.04,3.63,13.2,33.05,140,{"$f":"D9*K9/1000","v":0.98},{"$nulls":4},140,{"$f":"D9*K9/1000","v":0.98}]
[null,null,"лук",10,8,{"$nulls":12},0]
[null,null,"морковь",15,10,{"$nulls":12},0]
[null,null,"Томат паста",5,5,null,0.23,0,0.97,2.16,175,{"v":0.875,"d":"0.88"},{"$nulls":4},175,0.875]
[null,null,"рис",35,35,null,1.16,0.42,10.58,52.55,90,3.15,90,{"$f":"D13*K13/1000","v":3.15}]
[null,null,"соль",1,1,{"$nulls":5},{"v":16,"d":"16.00"},{"v":0.016,"d":"0.02"},null,{"$f":"D14*K14/1000","v":{"v":0.016,"d":"0.02"}}]
[{"$nulls":5},250]
["№944","Чай с сахаром с лимоном","заварка",1,1,{"$nulls":5},688,{"v":0.688,"d":"0.69"},null,{"v":0.688,"d":"0.69"},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}}]
[null,null,"лимон",8,7,{"$nulls":5},170,1.36,170,1.36]
[null,null,"Сахар",15,15,{"$nulls":3},19.96,75.8,80,{"v":1.2,"d":"1.20"},80,{"v":1.2,"d":"1.20"},null,{"$f":"D18*O18/1000","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},200,{"$nulls":5},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"$f":"SUM(P16:P18)","v":0}]
[null,null,"хлеб",20,20,null,6.96,1.2,46,167.2,76,1.52,76,1.52]
[null,"хлеб","хлеб",30,30,null,6.96,1.2,46,167.2,78,2.34,78,2.34,null,{"$f":"D21*O21/1000","v":{"v":0,"d":"0.00"}},{"$f":"I21*P21/1000","v":{"v":0,"d":"0.00"}},0]
[null,null,"итого",null,null,60,{"$nulls":5},{"$f":"SUM(L8:L21)","v":{"v":36.429,"d":"36.43"}},null,{"$f":"SUM(N13:N21)","v":{"v":10.274000000000001,"d":"10.27"}},{"$nulls":3},{"$f":"SUM(R8:R21)","v":26.155}]
[null,"итого за день"]

{"sheet":"9","index":8,"n_rows":24,"n_cols":18,"rows_kept":24,"merged":[[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[4,0,8,0],[4,1,8,1],[13,0,17,0],[18,0,20,0],[23,0,23,1]]}
["№ рецепта",null,"Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[null,"Наименование блюд",{"$nulls":10},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[null,"9 день",{"$nulls":8},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,null,"капуста",60,50,null,0.15,null,2.85,13.5,25,{"$f":"D4*K4/1000","v":1.5},null,null,25,{"$f":"D4*K4/1000","v":{"v":1.5,"d":"1.50"}}]
["№273","Салат из св капусты","Морковь",8,5,null,1.1,0.8,6.1,29.2,{"v":25,"d":"25.00"},{"$f":"D5*K5/1000","v":0.2},null,null,25,{"$f":"D5*K5/1000","v":{"v":0.2,"d":"0.20"}}]
[null,null,"сахарный песок",3,3,{"$nulls":3},9.98,37.9,{"v":80,"d":"80.00"},0.24,null,null,80,0.24]
[null,null,"соль",1,1,{"$nulls":5},{"v":16,"d":"16.00"},0.016,{"v":16,"d":"16.00"},{"$f":"D7*K7/1000","v":{"v":0.016,"d":"0.02"}}]
[null,null,"Масло растительное",7,null,null,"-",9.9,null,89.9,{"v":140,"d":"140.00"},0.98,{"v":140,"d":"140.00"},{"$f":"D8*M8/1000","v":0.98}]
[null,null,"итого",null,null,100]
[null,"Котлеты рыбные","котлеты рыбные",102,100,null,27.4,5.24,0,110,325,33.15,{"$nulls":4},{"v":325,"d":"325.00"},{"$f":"D10*Q10/1000","v":33.15}]
[null,null,"Соль",2,2,{"$nulls":5},16,0.032,16,{"$f":"D11*M11/1000","v":{"v":0.032,"d":"0.03"}}]
[null,null,"Масло растительное",2,2,null,null,0.24,null,22.45,140,0.28,140,0.28]
[{"$nulls":5},"100"]
["№442","картофельное пюре ","картофель ",170,null,null,2,0.4,16.3,80,25,4.25,null,null,25,{"$f":"D14*K14/1000","v":4.25}]
[null,"пюре","молоко ",24,null,null,6.4,0.39,0.74,8.2,83,1.992,83,{"v":1.992,"d":"1.99"}]
[null,null,"Соль",1,null,null,"-","-","-","-",16,0.016,16,{"v":0.016,"d":"0.02"}]
[null,null,"Масло слив",5,null,null,0.02,2.5,0.04,23.1,900,4.5,900,{"v":4.5,"d":"4.50"}]
[null,null,"итого",null,null,180]
[944,"Чай  с сахаром","Заварка",1,1,null,null,"-","-","-",688,0.688,688,{"v":0.688,"d":"0.69"}]
[null,null,"Сахар",15,15,null,null,"-",14.9,56.8,80,1.2,80,{"v":1.2,"d":"1.20"}]
[null,null,"итого",null,null,200,{"$f":"SUM(G19:G20)","v":0},{"$f":"SUM(H19:H20)","v":0},14.9,56.8,null,0]
[null,null,"хлеб",20,20,null,6.96,1.2,32.96,181,76,1.52,76,1.52]
[null,"хлеб ","хлеб",30,30,null,6.96,1.2,32.96,167.2,78,2.34,78,2.34,null,{"v":0,"d":"0.00"},null,0]
["итого за день",{"$nulls":10},{"$f":"SUM(L4:L23)","v":{"v":52.903999999999996,"d":"52.9"}},null,{"$f":"SUM(N7:N23)","v":{"v":13.563999999999998,"d":"13.6"}},null,{"$f":"SUM(P4:P23)","v":{"v":6.1899999999999995,"d":"6.2"}},null,{"$f":"SUM(R10:R23)","v":{"v":33.15,"d":"33.2"}}]

{"sheet":"10","index":9,"n_rows":25,"n_cols":18,"rows_kept":25,"merged":[[0,0,2,0],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[4,0,9,0],[17,0,18,0]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[null,"10 день",{"$nulls":8},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[]
["№416","Салат из моркови","морковь",65,50,null,1.1,null,5.43,28.9,20,{"$f":"D5*K5/1000","v":{"v":1.3,"d":"1.30"}},null,{"$f":"D5*M5/1000","v":{"v":0,"d":"0.00"}},20,{"$f":"D5*O5/1000","v":{"v":1.3,"d":"1.30"}},null,{"$f":"D5*Q5/1000","v":0}]
[null,null,"соль",0.5,{"$nulls":6},16,{"$f":"D6*K6/1000","v":{"v":0.008,"d":"0.01"}},16,{"$f":"D6*M6/1000","v":{"v":0.008,"d":"0.01"}},null,{"$f":"D6*O6/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D6*Q6/1000","v":0}]
[null,null,"масло растительное ",10,10,null,0,6.93,null,89.9,140,{"v":1.4,"d":"1.40"},140,{"$f":"D7*M7/1000","v":{"v":1.4,"d":"1.40"}},null,{"$f":"D7*O7/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D7*Q7/1000","v":0}]
[null,null,"итого",null,null,60]
[{"$nulls":13},{"$f":"D9*M9/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D9*O9/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D9*Q9/1000","v":0}]
[null,"Птица тушеная в соусе","курица",100,50,null,27.4,5.24,0,110,270,{"v":27,"d":"27.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":270,"d":"270.0"},27]
[null,null,"Масло растительное",2,2,null,null,5.99,0,53.94,140,0.28,140,0.28,null,{"v":0,"d":"0.00"},null,0]
[null,null,"Мука пшеничная",4,4,null,0.62,0.06,4.13,20.04,40,0.16,40,0.16,null,{"v":0,"d":"0.00"},null,0]
[null,null,"Соль",1,1,{"$nulls":5},16,{"v":0.016,"d":"0.02"},16,{"v":0.016,"d":"0.02"},null,{"v":0,"d":"0.00"},null,0]
[null,null,"сметана",{"v":12.5,"d":"13"},13,{"$nulls":5},210,{"v":2.625,"d":"2.63"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":210,"d":"210.0"},2.625]
[{"$nulls":5},"250"]
[null,"Макароны отварные","Макаронные изд",53,53,null,5.9,1.65,30.95,167.5,60,3.18,null,{"$f":"D16*M16/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D16*O16/1000","v":{"v":0,"d":"0.00"}},60,{"$f":"D16*Q16/1000","v":3.18}]
[null,null,"Масло сливочное",5,5,null,0.04,3.6,0.06,33.05,900,{"v":4.5,"d":"4.50"},900,{"$f":"D17*M17/1000","v":{"v":4.5,"d":"4.50"}},null,{"$f":"D17*O17/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D17*Q17/1000","v":0}]
["№746",null,"Соль",1,1,null,"-","-",null,null,16,{"v":0.016,"d":"0.02"},16,{"$f":"D18*M18/1000","v":{"v":0.016,"d":"0.02"}},null,{"$f":"D18*O18/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D18*Q18/1000","v":0}]
[null,null,"итого",null,null,180]
[null,"Кофейный напиток с молоком","кофейный напиток",5,5,null,null,"-","-","-",500,{"v":2.5,"d":"2.50"},500,{"$f":"D20*M20/1000","v":{"v":2.5,"d":"2.50"}},null,{"$f":"D20*O20/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D20*Q20/1000","v":0}]
[null,null,"Сахар",20,20,null,0,"-",14.9,56.8,80,{"v":1.6,"d":"1.60"},80,{"$f":"D21*M21/1000","v":{"v":1.6,"d":"1.60"}},null,{"$f":"D21*O21/1000","v":{"v":0,"d":"0.00"}},null,{"$f":"D21*Q21/1000","v":0}]
[944,null,"итого",null,null,200,{"$f":"SUM(G20:G21)","v":0},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"хлеб",20,20,20,6.96,1.2,46,167.2,76,1.52,76,1.52]
[null,"хлеб иодированный","хлеб",30,30,30,6.96,1.2,46,167.2,78,2.34,78,{"$f":"D24*M24/1000","v":2.34},null,{"v":0,"d":"0.00"},null,0]
[null,"итого за день",{"$nulls":9},{"$f":"SUM(L5:L24)","v":{"v":48.44500000000001,"d":"48.4"}},null,{"$f":"SUM(N5:N24)","v":{"v":14.339999999999998,"d":"14.3"}},null,{"$f":"SUM(P5:P24)","v":1.3},null,{"$f":"SUM(R5:R24)","v":{"v":32.805,"d":"32.8"}}]

{"sheet":"11","index":10,"n_rows":20,"n_cols":18,"rows_kept":20,"merged":[[0,0,2,0],[0,1,2,1],[0,2,2,2],[0,3,2,3],[0,4,2,4],[0,5,2,5],[0,6,2,6],[0,7,2,7],[0,8,2,8],[0,9,2,9],[0,10,1,11],[0,12,0,17],[1,12,1,13],[1,14,1,15],[1,16,1,17],[4,0,10,0],[4,1,10,1],[11,0,14,0],[11,1,13,1]]}
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[{"$nulls":10},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
[null,"11 день"]
[null,"Запеканка картофельная с мясом","говядина котлетное мясо",63,63,null,16.69,12.9,0,165.5,500,{"$f":"D5*K5/1000","v":{"v":31.5,"d":"31.50"}},{"$nulls":4},500,{"$f":"D5*K5/1000","v":31.5}]
[null,null,"Масло растительное",5,5,null,1.95,4.9,null,8.82,140,{"v":0.7,"d":"0.70"},{"$nulls":4},140,{"$f":"D6*K6/1000","v":0.7}]
[null,null,"Картофель",230,200,null,92,0.1,6.4,26.5,25,5.75,null,null,25,5.75]
[null,null,"лук",15,10,null,0.15,0.02,0.35,1.44,30,0.45,null,null,30,0.45]
[null,null,"масло сливочное ",11,null,null,0.04,3.63,0.13,33.05,900,{"v":9.9,"d":"9.90"},{"$nulls":4},900,{"$f":"D9*Q9/1000","v":9.9}]
[null,null,"Соль",1,1,null,"-","-","-","-",16,{"v":0.016,"d":"0.02"},16,{"$f":"D10*K10/1000","v":{"v":0.016,"d":"0.02"}}]
[null,null,"итого",null,null,250]
["№944","Чай с лимоном","заварка",1,null,null,1.02,null,21.76,87.14,688,{"v":0.688,"d":"0.69"},688,{"v":0.688,"d":"0.69"}]
[null,null,"сахар",15,null,null,1.36,null,29.02,116.19,80,{"v":1.2,"d":"1.20"},80,{"v":1.2,"d":"1.20"}]
[null,null,"лимон",8,{"$nulls":6},170,1.36,170,1.36]
[{"$nulls":5},200,{"$f":"SUM(G12:G14)","v":2.38},{"$f":"SUM(H12:H14)","v":0},{"$f":"SUM(I12:I14)","v":50.78},{"$f":"SUM(J12:J14)","v":203.32999999999998},null,{"v":0,"d":"0.00"}]
[null,"хлеб","хлеб",20,20,20,6.96,1.2,32.96,181,76,1.52,76,1.52]
[null,"хлеб","хлеб",30,30,30,6.96,1.2,32.96,167.2,78,2.34,78,2.34]
[null,"Масло слив.","масло сливочное ",10,null,null,0.08,7.25,0.26,66.1,900,{"v":9,"d":"9.00"},{"$nulls":4},{"v":900,"d":"900.00"},{"$f":"D18*Q18/1000","v":9}]
[null,"Сыр","Сыр гол.",15,null,15,2.26,2.57,null,33.79,610,9.15,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":610,"d":"610.00"},{"$f":"D19*Q19/1000","v":9.15}]
[null,null,"итого",{"$nulls":8},{"$f":"SUM(L5:L19)","v":{"v":73.57400000000001,"d":"73.57"}},null,{"$f":"SUM(N5:N19)","v":{"v":7.1240000000000006,"d":"7.12"}},null,{"$f":"SUM(P7:P19)","v":{"v":6.2,"d":"6.20"}},null,{"$f":"SUM(R5:R19)","v":60.25}]

{"sheet":"12","index":11,"n_rows":26,"n_cols":18,"rows_kept":26,"merged":[[1,0,3,0],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,2,11],[1,12,1,17],[2,12,2,13],[2,14,2,15],[2,16,2,17],[4,1,5,1],[20,1,21,1]]}
[]
["№ рецепта","Наименование блюд","Основные компоненты","Брутто","Нетто","Выход","Белки","Жиры","Углеводы","Ккал","Всего",null,"В том числе"]
[{"$nulls":12},"Бюджет",null,"За счет собственной продукции",null,"Родительский взнос\n плата"]
[null,"12 день",{"$nulls":8},"Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма","Цена за кг","Сумма"]
["№297","Запеканка рисовая с творогом","рис",30,30,null,3.36,0.57,30.36,156.8,90,{"$f":"D5*K5/1000","v":{"v":2.7,"d":"2.70"}},90,2.16]
[null,null,"творог",25,25,null,6.76,3.75,0.81,64.4,322,{"$f":"D6*K6/1000","v":8.05},{"$nulls":4},322,{"$f":"D6*K6/1000","v":8.05}]
[null,null,"Яйцо",0.2,0.2,null,1.27,1.15,0.07,15.7,10,{"v":2E-3,"d":"0.00"},{"$nulls":4},10,{"$f":"D7*K7/1000","v":2E-3}]
[null,null,"Сахар",7.5,7.5,{"$nulls":3},14.97,56.85,80,{"v":0.6,"d":"0.60"},80,{"v":0.6,"d":"0.60"}]
[null,null,"Масло слив",10,10,null,0.04,3.63,0.28,33.05,900,{"v":9,"d":"9.00"},{"$nulls":4},{"v":900,"d":"900.00"},9]
[null,null,"сметана",5,5,null,0.14,1,0.16,10.3,210,1.05,{"$nulls":4},{"v":210,"d":"210.00"},1.05]
[{"$nulls":5},220]
["№945","Чай с сахаром","заварка",1,1,{"$nulls":5},{"v":688,"d":"688.0"},{"v":0.688,"d":"0.69"},{"$nulls":4},688,0.688]
[null,null,"Сахар",15,15,{"$nulls":5},{"v":80,"d":"80.0"},{"v":1.2,"d":"1.20"},{"$nulls":4},80,1.2]
[{"$nulls":5},200]
[null,"хлеб","хлеб",30,30,null,{"v":6.96,"d":"7.0"},1.2,{"v":32.96,"d":"33.0"},{"v":181,"d":"181.0"},{"v":78,"d":"78.0"},2.34,{"$nulls":4},78,2.34]
[null,null,"хлеб",20,20,null,{"v":6.96,"d":"7.0"},1.2,{"v":32.96,"d":"33.0"},{"v":181,"d":"181.0"},{"v":76,"d":"76.0"},1.52,null,0,null,null,76,1.52]
[{"$nulls":11},{"$f":"SUM(L5:L16)","v":27.15},null,{"$f":"SUM(N5:N16)","v":{"v":2.7600000000000002,"d":"2.76"}},{"$nulls":3},{"$f":"SUM(R6:R16)","v":23.849999999999998}]
[]
[]
[]
[]
[]
[]
[null,"ИТОГО НА 1 РЕБ"]
[null,"ОБЩИЙ",{"$nulls":9},670.67,null,145.89,null,29.52,null,494.11]
[{"$nulls":11},55.89,null,12.16,{"$nulls":3},41.17]